UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GKeYroaDLm9jQgubU0unEhYW5XuIAqPXAdEB92lf9uM='
WHERE
key_id = '5db888a70d54cee491ad8fe1b07fa6a1198123975587e3ca441d0d1307eb3bb5'
AND (
token = 'GKeYroaDLm9jQgubU0unEhYW5XuIAqPXAdEB92lf9uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)