UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQFruXy6hCBZ9STE3S/Lb/p/lguT6YJwaaQTHkmHYY4='
WHERE
key_id = 'cae7c5aa16ff6ea2bc7fe995d429448f2fa18f217d621597105ab4bad8b1fa0f'
AND (
token = 'LQFruXy6hCBZ9STE3S/Lb/p/lguT6YJwaaQTHkmHYY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)