UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r+Q6kA8+EQXUZDtIg4DlE+MDDXfE3uQEZOAlnf8IBgA=' 
WHERE 
  key_id = '1207f7b1915501d0733def3d76d0c73985956de249152f91b5b741ce50c895b2' 
  AND (
    token = 'r+Q6kA8+EQXUZDtIg4DlE+MDDXfE3uQEZOAlnf8IBgA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024