UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ahk3X8WIkQZPA1iefEs5Y/1Ca//n2yyMaIZkt0+tPr0=' 
WHERE 
  key_id = '89506c5444003a777741a7961f6cd96a5fdfca647c7cf7e67a9647932e08dcb5' 
  AND (
    token = 'Ahk3X8WIkQZPA1iefEs5Y/1Ca//n2yyMaIZkt0+tPr0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021