UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lTO6VH7h+HHFfHLTTMFj2OsirU8s3DzvmSNhFkyBhX8='
WHERE
key_id = '4d0bf6c2e70c1384e86ac2c606148e5c8818e5c09d04a99f147c7ed9637a0699'
AND (
token = 'lTO6VH7h+HHFfHLTTMFj2OsirU8s3DzvmSNhFkyBhX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)