UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QkwKpndq43q3JJBKpRtmhYpfAAGMGUiFHJExoHX5tvg='
WHERE
key_id = 'e970169229259ed6550319356fb9876f86d507a058d70db8cf07ee12b0d707b0'
AND (
token = 'QkwKpndq43q3JJBKpRtmhYpfAAGMGUiFHJExoHX5tvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)