UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uMVFJ1ntaboz4inc/FfAj23uujeaPYU4mS8Wt4gRI/I=' 
WHERE 
  key_id = '9cf9173147033e69cb02c9e62480a501746acda72aa7cc8d64e7a60bbf45b3f0' 
  AND (
    token = 'uMVFJ1ntaboz4inc/FfAj23uujeaPYU4mS8Wt4gRI/I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00050