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