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