UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHiToDcmvslPLF9l10bOHfRHCzXGO/E4zsUSouCd8GA='
WHERE
key_id = 'bbf6c87def5bea9186472ad86f8e7261b5494755d0b8d6733a2bdb3da5cb9d60'
AND (
token = 'pHiToDcmvslPLF9l10bOHfRHCzXGO/E4zsUSouCd8GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)