UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9giz6B72uSxq7TOt3aqdEVIJMU1rOqpgCn6aDKv0lQ='
WHERE
key_id = '489251b4ee52dc316f7e917389beab8aa5de030750466a4dba9967876c505686'
AND (
token = 'k9giz6B72uSxq7TOt3aqdEVIJMU1rOqpgCn6aDKv0lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)