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

Query time 0.00033