UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YNCbR2haNMq1CIXIXRtmtTw9ajd1oojPZTlyI6TSDlk='
WHERE
key_id = '3071e0dae5f8f3a491547f76caa7d7b0c4dd149846792723cb87cc468661c3ac'
AND (
token = 'YNCbR2haNMq1CIXIXRtmtTw9ajd1oojPZTlyI6TSDlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)