UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'akJ8HCJOms8cGQpRrWeyYs7WxmhJIt4tRkiyZ90ukZ8='
WHERE
key_id = 'd7ea033e81357e685cca441923eba7b35d8f38c48015ebc757b3b293cf72a0af'
AND (
token = 'akJ8HCJOms8cGQpRrWeyYs7WxmhJIt4tRkiyZ90ukZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)