UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xx6BjGDFFS4bG3lCIopdjg2MsCfwirpLtsm+qN1t408='
WHERE
key_id = 'fab549c27b195f0fb8efc1127061fc729ef966d6fdea0a2a604838dd8fbad78f'
AND (
token = 'Xx6BjGDFFS4bG3lCIopdjg2MsCfwirpLtsm+qN1t408='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)