UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H+8sRNZIIgabQ3cwKGYeAoscx9pkPL6aAVfMgBCWiQ0='
WHERE
key_id = 'c0e3de21b225bd762a34af45c808c6777d90be6c1048ed5ccb2cea3b08289ef4'
AND (
token = 'H+8sRNZIIgabQ3cwKGYeAoscx9pkPL6aAVfMgBCWiQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)