UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8J/3VJhWFJjUQZYRZH1jpXdzWw6hlrrEW4MpdLe5oKA='
WHERE
key_id = '189d568ce63b182e342f26ec09a59a8ce67e5410d5f70ffacc310bf65a2405cd'
AND (
token = '8J/3VJhWFJjUQZYRZH1jpXdzWw6hlrrEW4MpdLe5oKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)