UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsWI30fQAbm8t+9FOMoWJXN8OWfNJeeImk3exLv/Gic='
WHERE
key_id = '9ae801e7fc9a21dc359d8973be81524c13448f7534a120767e6d0b0188f27fc8'
AND (
token = 'ZsWI30fQAbm8t+9FOMoWJXN8OWfNJeeImk3exLv/Gic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)