UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCZTTbgEBAWt0f/cJWWKMJhKC9GmG1UGrH0HpOalOwI='
WHERE
key_id = '4d0336a6d4d6ea040de9525fbce3a4147ae33cacd4ec728d9f7e2ee3224dda1d'
AND (
token = 'cCZTTbgEBAWt0f/cJWWKMJhKC9GmG1UGrH0HpOalOwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)