UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5eYp1YnIpJYBoitGdkuzdm/g6qSemgrdKWTHMtIhyI='
WHERE
key_id = 'e6e7e6e8c81913628e1152b4c0669ce1d448f1acf63ecf6a3a5dcee04a741fd2'
AND (
token = 'G5eYp1YnIpJYBoitGdkuzdm/g6qSemgrdKWTHMtIhyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)