UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGceN8RrcroTyGGIQKX3NQuKvJa08/28uoNZQFjbXFA='
WHERE
key_id = '1dc5b860bd8d3424e76bfa238d6e7920c573493d31e3ce51527a3bdccff10056'
AND (
token = 'cGceN8RrcroTyGGIQKX3NQuKvJa08/28uoNZQFjbXFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)