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

Query time 0.00048