UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnhBrqC7sev1W4WAAeCsAEpKMoTpQpr3wnTNJ34irFg='
WHERE
key_id = '0c58ba811590abffe1f62d4d5fc4948f5ae88e69ca8bf7b5d93e7e2e2a74609c'
AND (
token = 'XnhBrqC7sev1W4WAAeCsAEpKMoTpQpr3wnTNJ34irFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)