UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80zvZJ1SWsqMfFsiFj6PTvWIka3mYt8QW5XPfF6CBOU='
WHERE
key_id = 'be42c0fbcc075bebf29d426b797e910bdc0869b656fa2b9e09b59f2fdb7b696e'
AND (
token = '80zvZJ1SWsqMfFsiFj6PTvWIka3mYt8QW5XPfF6CBOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)