UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XogS8kpK1RC5Nda4rfeXg3tIz6t9vtTU18cNcQpiXaA='
WHERE
key_id = '1be7f225078f729386da89dc2270fb45d6bfbfed20c11e3e754467622d644b01'
AND (
token = 'XogS8kpK1RC5Nda4rfeXg3tIz6t9vtTU18cNcQpiXaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)