UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CvV7065fbmi726v4vd162PTcWa2jpF4Vht8se6T/cm8='
WHERE
key_id = '9bafcb1674181631534a93d208e0fc476388bf404fab952ac942cc7f46583a63'
AND (
token = 'CvV7065fbmi726v4vd162PTcWa2jpF4Vht8se6T/cm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)