UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3PER/DZuZKBb4eFPevE/lpMwCQMYtfBgk9+0+P2nKyY='
WHERE
key_id = 'a6a9f03156a8bf72038ec5ce958557b868da26227809aad06c7805c2a034c4db'
AND (
token = '3PER/DZuZKBb4eFPevE/lpMwCQMYtfBgk9+0+P2nKyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)