UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THoYy8+UGIwo3PdivzNgdBpFD5CJFr3/x6EL6BZIHAQ='
WHERE
key_id = 'd29bac7bc8d18e8935d8430052a8e07a8e58049db83e404c7c3c3a98864df562'
AND (
token = 'THoYy8+UGIwo3PdivzNgdBpFD5CJFr3/x6EL6BZIHAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)