UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2m9qwznrF3G1cbOAVxBr940PA6ovafLU83gTBFQq+D4=' 
WHERE 
  key_id = '896beb711d9c44898f85fa0134b625f6c0b7c136c07a03c50a9c9756805ed270' 
  AND (
    token = '2m9qwznrF3G1cbOAVxBr940PA6ovafLU83gTBFQq+D4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031