UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZnwhcV+4e3UvhoUcb6+OXgpTBrsB0TzB6GYqGPqWgI='
WHERE
key_id = '28e088aef72d44aae53c1caf408e89704ebaa24d15feec0190c58048d78cca33'
AND (
token = '9ZnwhcV+4e3UvhoUcb6+OXgpTBrsB0TzB6GYqGPqWgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)