UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Be1scgBuMgPX9jaXFCCJZynygOYuzeyKhe4csIP7O4w='
WHERE
key_id = '4ca3930b8ea17ee87059ef5e6c8247c1517f11d46efa49a9e94f673cdd96ff8f'
AND (
token = 'Be1scgBuMgPX9jaXFCCJZynygOYuzeyKhe4csIP7O4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)